SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW [dbo].[ImportPODetails]
AS
SELECT  PODetails.POId ,
        PODetails.DrugId ,
        PODetails.Quantity ,
        PODetails.RemainQuantity ,
        PODetails.Remark ,
        PODetails.PODetailId ,
        DrugDispo.DrugName ,
        DrugDispo.Unit ,
        DrugDispo.CostPrice ,
        DrugDispo.SellPrice ,
        MarkUpType.MarkUpPercent ,
        MarkUpType.MarkUpName
FROM    PODetails
        INNER JOIN DrugDispo ON PODetails.DrugId = DrugDispo.DrugId
        INNER JOIN MarkUpType ON DrugDispo.MarkUpType = MarkUpType.MarkUpType
GO
